//  Copyright (c) 2010 Mahesh Sharma,Matt MacDonald
//
//  Permission is hereby granted, free of charge, to any person obtaining a copy
//  of this software and associated documentation files (the "Software"), to deal
//  in the Software without restriction, including without limitation the rights
//  to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
//  copies of the Software, and to permit persons to whom the Software is
//  furnished to do so, subject to the following conditions:
//
//  The above copyright notice and this permission notice shall be included in
//  all copies or substantial portions of the Software.
//
//  THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
//  IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
//  FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
//  AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
//  LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
//  OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
//  THE SOFTWARE.

package org.prx.prp.controller;

import java.util.ArrayList;

import org.prx.prp.model.AppConstant;
import org.prx.prp.utility.DatabaseAdapter;

import android.database.Cursor;

public class AppConstantManager {
public static AppConstant getById(Integer appConstantId)
{
	
	Cursor c=DatabaseAdapter.executeQuery("SELECT AD_CONSTANTS.ID AS APP_CONSTANT_ID, AD_CONSTANTS.NAME AS APP_CONSTANT_NAME, AD_CONSTANTS.VALUE AS APP_CONSTANT_VALUE FROM AD_CONSTANTS WHERE AD_CONSTANTS.ID = ?", new String[]{appConstantId.toString()});
	AppConstant appConstant=new AppConstant(c);
	c.close();
	return appConstant;
}
public static AppConstant getByName(String appConstantName)
{
	Cursor c=DatabaseAdapter.executeQuery("SELECT AD_CONSTANTS.ID AS APP_CONSTANT_ID, AD_CONSTANTS.NAME AS APP_CONSTANT_NAME, AD_CONSTANTS.VALUE AS APP_CONSTANT_VALUE FROM AD_CONSTANTS WHERE AD_CONSTANTS.NAME = ?",new String[]{appConstantName});
	AppConstant appConstant=new AppConstant(c);
	c.close();
	return appConstant;
}
public static ArrayList<AppConstant> getAll()
{
	Cursor c=DatabaseAdapter.executeQuery("SELECT AD_CONSTANTS.ID AS APP_CONSTANT_ID, AD_CONSTANTS.NAME AS APP_CONSTANT_NAME, AD_CONSTANTS.VALUE AS APP_CONSTANT_VALUE FROM AD_CONSTANTS",null);	
	ArrayList<AppConstant> results=null;
	if (c != null) {
		c.moveToFirst();
		if (c.isAfterLast()) {
			c.close();
			return results;
		}
		results = new ArrayList<AppConstant>(c.getCount());
		do {
			results.add(new AppConstant(c));
		}
		while (c.moveToNext());
	}
	c.close();	
	return results;	
}
}
